﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.Odbc;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

public partial class public_html_NewSite_CMSV2_GamesList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ReviewerMySql SQL = new ReviewerMySql();
        OdbcDataReader Reader = SQL.ExecuteReader("SELECT V2_GloFormat.Navn, V2_Spil.* FROM V2_Spil JOIN V2_GloFormat ON V2_Spil.Format = V2_GloFormat.ID ORDER BY Titel");
        while (Reader.Read())
        {
            ListItem item = new ListItem();
            BullitList_Game.Items.Add(new ListItem(Reader["Titel"].ToString() + " (" + Reader["Navn"].ToString() + ")", "ReviewsAdd.aspx?id=" + Reader["ID"].ToString() + "&titel=" + Reader["Titel"].ToString() + " (" + Reader["Navn"].ToString() + ")&Format=" + Reader["Format"].ToString()));
        }
    }
}
